Aurora
- Proprietary database by
AWS - Data is replicated to
6 Replicasin3 AZ - Auto healing capability
- Multi AZ
- Auto scaling read-replica
- Storage from
10GBto64TB Aurora Globaldatabase forDRandLatency Uses- Need to provision
EC2 InstanceandEBS Volume - Using
Aurora Serverlessdoes not requireinstanceandvolume 5xfaster than regularRDMS- Support
MAX 15 Read Replicas - We can create custom endpoint for
- Production Database
- Reporting queries
- Built in
reader-endpointcan be used for distribute the traffic between read-replicas - If
DB Primary Instancefails, it create a newDB Instancein the same AZ as theOriginal Instanceand done byBest Effort basis Read Replicascan be used to avoid un necessary downtime- With
binlogreplication, another aurora cluster can be used as read replica. Aurora cluster can be same or different region - Aurora auto scaling policy can be used to adjust performance
- Based of number of connections (when the lambda function is using the database)